from applications.extensions import db
class SptNotice(db.Model):
    """
    省平台公告信息表
    """
    __tablename__ = 'spt_notice'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)  # 设置主键, 默认自增
    announcementGuid = db.Column(db.String(256))
    isDeleted = db.Column(db.String(256))
    unifiedDealCode = db.Column(db.String(256))
    announcementCode = db.Column(db.String(256))
    announcementTitle = db.Column(db.String(256))
    announcementType = db.Column(db.String(256))
    publishingTime = db.Column(db.String(256))
    url = db.Column(db.String(256))
    endDate = db.Column(db.String(256))
    announcementStartTime = db.Column(db.String(256))
    listingStartTime = db.Column(db.String(256))
    listingDeadline = db.Column(db.String(256))
    listingType = db.Column(db.String(256))
    supplyType = db.Column(db.String(256))
    fieldNum = db.Column(db.String(256))
    landDistrict = db.Column(db.String(256))
    announcementUnit = db.Column(db.String(256))
    liaisonUnit = db.Column(db.String(256))
    unitAddress = db.Column(db.String(256))
    zipCode = db.Column(db.String(256))
    contactPerson = db.Column(db.String(256))
    contactNumber = db.Column(db.String(256))
    email = db.Column(db.String(256))
    createTime = db.Column(db.String(256))
    changeTime = db.Column(db.String(256))
    retreatTime = db.Column(db.String(256))
    attachmentSetCode = db.Column(db.String(256))
    platformCode = db.Column(db.String(256))
    pubServicePlatCode = db.Column(db.String(256))
    dataTimestamp = db.Column(db.String(256))
    uploadGJStatus = db.Column(db.String(256))
    announcementDeadline = db.Column(db.String(256))
    jyptId = db.Column(db.String(256))
    cancelReason = db.Column(db.String(256))
    GGID = db.Column(db.String(256))